﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'MarcaDelete')
	BEGIN
		DROP  Procedure  MarcaDelete
	END
GO

CREATE PROCEDURE MarcaDelete
	(	
		@id		AS INT,
		@user	AS VARCHAR(30)
	)	
AS
BEGIN	
	SET NOCOUNT ON
	
	UPDATE Marca
	SET Activo = 0,
		FechaModificacion = GETDATE(),
		ModificadoPor = @user		
	WHERE MarcaId = @id

	SET NOCOUNT OFF
END
GO 